SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 52844: The %TKMI_JOB_RO etl_end_service task might generate the error "Assertion failed: prod_geos_size>0..."

DetailsHotfixAboutRate It

The SAS® Revenue Optimization %TKMI_JOB_RO etl_end_service task might generate the following error in the MerchIntelGridSvr.log:

<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : Processing Benefits Tracking <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : ERROR: Assertion failed: prod_geos_size>0, file /sas/dev/mva-f3ro52/dippr/src/rpp_cost_service.c, line 1699 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : ERROR: [rpp_cost_service_run] prod_geos_size is zero <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_pdr : Completed Processing Geo_Prod_Promo_Price_Avg in <n> seconds <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_pga : Completed Processing Geo_Prod_Agg in <n> seconds <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : Error: job 'prep_<partition_id>_bt' encountered a fatal error <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: ERROR: TKTException code = 6 (Access violation) <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #4 0x00007fd60e97e7ec in tkmi_exception_handler (thread=0x4b75, ctxt=0x7fd5a2af4e9c, code=TKTE_UnknownException) at /sas/dev/mva-f3ro52/di/src/tkmi_exception.c:88 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #5 0x00007fd61849e196 in bktExcept () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #6 0x00007fd6184a119b in bkt_segv () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #7 0x00007fd61849e764 in bkt_signal_handler () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #8 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #9 assert_fn (cond=-264706176, cond_str=0x0, file=0x0, line=65792, msg=0x7fd5a2af6700 "") at /sas/dev/mva-f3ro52/di/src/base.c:1648 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #10 0x00007fd60ec37e0f in rpp_cost_service_run (rpp_manager=0x35f038e780, prod_geos=0x0, prod_geos_size=0, start_dt=65792, end_dt=-1565563136, plan_status_cd=-1816096496, plan_sk_list=0x7fd60ee674d8 "", use_freeze_period=1, output_promotion_fee=0, opt=0x7fd5a2ae89c0) at /sas/dev/mva-f3ro52/dippr/src/rpp_cost_service.c:1699 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #11 0x00007fd60ebe0e40 in load_cost (ctx=0x35f038e780) at /sas/dev/mva-f3ro52/dipca/src/rpo_benefits_tracking_service.c:459 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #12 0x00007fd60ebdf4f7 in rpo_benefits_tracking_service_batch (dim=0x7fd6094e21b0) at /sas/dev/mva-f3ro52/dipca/src/rpo_benefits_tracking_service.c:1322 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #13 0x00007fd60eab87ab in prep_service_bt (context=0x35f038e780) at /sas/dev/mva-f3ro52/di/src/prep_service.c:552 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #14 0x00007fd60e96a668 in logic_fn (ctxt=0x7fd61837c0a0, req=0x7fd5dd6bb5f0, thread=0x7fd6183a8e10, cb=0x7fd6096b0928) at /sas/dev/mva-f3ro52/di/src/job_manager.c:1281 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #15 0x00007fd60d5a6d0b in basicPuddleMain () from <sasroot>/SASFoundation/9.3/sasexe/tkepdl.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #16 0x00007fd61849c9a6 in sktMain () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #17 0x00007fd61849dffb in bktMain () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #18 0x00000035f08079d1 in start_thread () from /lib64/libpthread.so.0 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #19 0x00000035f00e8b6d in clone () from /lib64/libc.so.6

The error is generated during SAS® Regular Price Optimization benefits tracking processing that occurs during the batch preparation jobs in the etl_end_service task.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Regular Price OptimizationLinux for x645.2_M35.49.3 TS1M29.4 TS1M3
Microsoft® Windows® for x645.2_M35.49.3 TS1M29.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.